Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 4254339 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.5 GiB |
| Average record size in memory | 895.0 B |
Variable types
| Numeric | 6 |
|---|---|
| DateTime | 1 |
| Categorical | 12 |
store_name has a high cardinality: 2257 distinct values | High cardinality |
deposit/distributor has a high cardinality: 77 distinct values | High cardinality |
municipality/city has a high cardinality: 606 distinct values | High cardinality |
units is highly correlated with total | High correlation |
total is highly correlated with units | High correlation |
units is highly correlated with total | High correlation |
total is highly correlated with units | High correlation |
units is highly correlated with total | High correlation |
total is highly correlated with units | High correlation |
division is highly correlated with grade and 3 other fields | High correlation |
sku_subcategory is highly correlated with sku_description and 1 other fields | High correlation |
format is highly correlated with supplier | High correlation |
grade is highly correlated with division and 3 other fields | High correlation |
supplier is highly correlated with format and 1 other fields | High correlation |
sku_description is highly correlated with sku_subcategory and 2 other fields | High correlation |
state is highly correlated with division and 3 other fields | High correlation |
structure is highly correlated with division and 3 other fields | High correlation |
sku_category is highly correlated with sku_subcategory and 1 other fields | High correlation |
deposit/distributor is highly correlated with division and 3 other fields | High correlation |
id is highly correlated with store_id and 3 other fields | High correlation |
store_id is highly correlated with id and 3 other fields | High correlation |
format is highly correlated with id and 6 other fields | High correlation |
structure is highly correlated with format and 4 other fields | High correlation |
division is highly correlated with structure and 3 other fields | High correlation |
deposit/distributor is highly correlated with store_id and 5 other fields | High correlation |
state is highly correlated with format and 4 other fields | High correlation |
supplier is highly correlated with id and 3 other fields | High correlation |
grade is highly correlated with structure and 3 other fields | High correlation |
sku is highly correlated with sku_description and 3 other fields | High correlation |
sku_description is highly correlated with id and 7 other fields | High correlation |
sku_category is highly correlated with sku and 3 other fields | High correlation |
sku_subcategory is highly correlated with sku and 3 other fields | High correlation |
units is highly correlated with unit_price and 1 other fields | High correlation |
unit_price is highly correlated with sku and 5 other fields | High correlation |
total is highly correlated with sku_description and 2 other fields | High correlation |
id has unique values | Unique |
Reproduction
| Analysis started | 2021-10-17 15:56:36.295369 |
|---|---|
| Analysis finished | 2021-10-17 16:00:51.770806 |
| Duration | 4 minutes and 15.48 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 4254339 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2638617.371 |
| Minimum | 0 |
|---|---|
| Maximum | 5489595 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 48.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 259874.9 |
| Q1 | 1310655.5 |
| median | 2627263 |
| Q3 | 3950203 |
| 95-th percentile | 5081388.4 |
| Maximum | 5489595 |
| Range | 5489595 |
| Interquartile range (IQR) | 2639547.5 |
Descriptive statistics
| Standard deviation | 1537052.559 |
|---|---|
| Coefficient of variation (CV) | 0.5825219585 |
| Kurtosis | -1.164308021 |
| Mean | 2638617.371 |
| Median Absolute Deviation (MAD) | 1319790 |
| Skewness | 0.03271820983 |
| Sum | 1.122557279 × 1013 |
| Variance | 2.362530568 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4196351 | 1 | < 0.1% |
| 4677055 | 1 | < 0.1% |
| 374242 | 1 | < 0.1% |
| 370144 | 1 | < 0.1% |
| 4480479 | 1 | < 0.1% |
| 284126 | 1 | < 0.1% |
| 4488667 | 1 | < 0.1% |
| 292314 | 1 | < 0.1% |
| 4484569 | 1 | < 0.1% |
| 4464087 | 1 | < 0.1% |
| Other values (4254329) | 4254329 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 5489595 | 1 | |
| 5489587 | 1 | |
| 5489584 | 1 | |
| 5489580 | 1 | |
| 5489577 | 1 | |
| 5489573 | 1 | |
| 5489571 | 1 | |
| 5489570 | 1 | |
| 5489564 | 1 | |
| 5489557 | 1 |
date
Date
| Distinct | 397 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 64.9 MiB |
| Minimum | 2016-01-01 00:00:00 |
|---|---|
| Maximum | 2017-06-04 00:00:00 |
| Distinct | 2311 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2636.168118 |
| Minimum | 2 |
|---|---|
| Maximum | 5855 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.9 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 239 |
| Q1 | 1661 |
| median | 2676 |
| Q3 | 3703 |
| 95-th percentile | 5440 |
| Maximum | 5855 |
| Range | 5853 |
| Interquartile range (IQR) | 2042 |
Descriptive statistics
| Standard deviation | 1330.483814 |
|---|---|
| Coefficient of variation (CV) | 0.504703704 |
| Kurtosis | -0.257816153 |
| Mean | 2636.168118 |
| Median Absolute Deviation (MAD) | 1020 |
| Skewness | 0.1858588328 |
| Sum | 1.121515284 × 1010 |
| Variance | 1770187.178 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1003 | 4460 | 0.1% |
| 1016 | 4201 | 0.1% |
| 3747 | 4195 | 0.1% |
| 1770 | 4152 | 0.1% |
| 2384 | 4128 | 0.1% |
| 1084 | 4116 | 0.1% |
| 3505 | 4109 | 0.1% |
| 3895 | 4055 | 0.1% |
| 4073 | 4045 | 0.1% |
| 3847 | 4044 | 0.1% |
| Other values (2301) | 4212834 |
| Value | Count | Frequency (%) |
| 2 | 1800 | |
| 4 | 1111 | |
| 5 | 1585 | |
| 6 | 1092 | |
| 7 | 1149 | |
| 8 | 1099 | |
| 9 | 1381 | |
| 10 | 1287 | |
| 11 | 1064 | |
| 12 | 1566 |
| Value | Count | Frequency (%) |
| 5855 | 3433 | |
| 5851 | 2866 | |
| 5850 | 2889 | |
| 5844 | 2619 | |
| 5843 | 3221 | |
| 5827 | 3211 | |
| 5825 | 3646 | |
| 5817 | 3387 | |
| 5815 | 3544 | |
| 5813 | 2701 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 295.9 MiB |
| Grocery | |
|---|---|
| AllInOne | |
| Leftorium | |
| SmallShop | |
| GipsyTrade | |
| Other values (4) |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 7.925143248 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Grocery |
|---|---|
| 2nd row | AllInOne |
| 3rd row | AllInOne |
| 4th row | Leftorium |
| 5th row | Grocery |
Common Values
| Value | Count | Frequency (%) |
| Grocery | 1202193 | |
| AllInOne | 1147815 | |
| Leftorium | 814123 | |
| SmallShop | 430472 | 10.1% |
| GipsyTrade | 315696 | 7.4% |
| Shop | 263019 | 6.2% |
| GreatShop | 68538 | 1.6% |
| TinyShop | 8122 | 0.2% |
| BigCom | 4361 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| grocery | 1202193 | |
| allinone | 1147815 | |
| leftorium | 814123 | |
| smallshop | 430472 | 10.1% |
| gipsytrade | 315696 | 7.4% |
| shop | 263019 | 6.2% |
| greatshop | 68538 | 1.6% |
| tinyshop | 8122 | 0.2% |
| bigcom | 4361 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2257 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 349.7 MiB |
| Bizarre Crimson Fishmonger | 6596 |
|---|---|
| Bloody Chocolate AllInOne | 6305 |
| Enlightened Cyan HairDresser | 5854 |
| Enlightened Lavender GipsyTrade | 5755 |
| Bad Sky Blue Mall | 5580 |
| Other values (2252) |
Length
| Max length | 33 |
|---|---|
| Median length | 21 |
| Mean length | 21.19869127 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Old Indigo BigCom |
|---|---|
| 2nd row | Dead Burgundy Shop |
| 3rd row | Kicking Orange HairDresser |
| 4th row | Funny Maroon LunchHall |
| 5th row | Defiant Red Mall |
Common Values
| Value | Count | Frequency (%) |
| Bizarre Crimson Fishmonger | 6596 | 0.2% |
| Bloody Chocolate AllInOne | 6305 | 0.1% |
| Enlightened Cyan HairDresser | 5854 | 0.1% |
| Enlightened Lavender GipsyTrade | 5755 | 0.1% |
| Bad Sky Blue Mall | 5580 | 0.1% |
| Defiant Orange Butcher | 5480 | 0.1% |
| Awesome Lemon BookShop | 5416 | 0.1% |
| Kicking Brown Convenience | 5294 | 0.1% |
| Short Olive BigCom | 5291 | 0.1% |
| Horrible Black Leftorium | 5086 | 0.1% |
| Other values (2247) | 4197682 |
Length
| Value | Count | Frequency (%) |
| green | 233923 | 1.8% |
| blue | 225298 | 1.7% |
| shop | 158409 | 1.2% |
| stationer | 156755 | 1.2% |
| fishmonger | 153940 | 1.2% |
| market | 153812 | 1.2% |
| butcher | 149862 | 1.2% |
| deli | 148909 | 1.2% |
| grocery | 147076 | 1.1% |
| baker | 145027 | 1.1% |
| Other values (102) | 11232126 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 294.7 MiB |
| FORANEO | |
|---|---|
| METRO | |
| DISTRIBUIDORES |
Length
| Max length | 14 |
|---|---|
| Median length | 7 |
| Mean length | 7.636841587 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FORANEO |
|---|---|
| 2nd row | DISTRIBUIDORES |
| 3rd row | FORANEO |
| 4th row | FORANEO |
| 5th row | METRO |
Common Values
| Value | Count | Frequency (%) |
| FORANEO | 2013950 | |
| METRO | 1441487 | |
| DISTRIBUIDORES | 798902 | 18.8% |
Length
Pie chart
| Value | Count | Frequency (%) |
| foraneo | 2013950 | |
| metro | 1441487 | |
| distribuidores | 798902 | 18.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 318.7 MiB |
| METRO-NORTE | |
|---|---|
| METRO-SUR | |
| CENTRO | |
| BAJÍO | |
| OCCIDENTE | |
| Other values (6) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.216916894 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CENTRO |
|---|---|
| 2nd row | CENTRO |
| 3rd row | CENTRO-SUR |
| 4th row | CENTRO |
| 5th row | METRO-NORTE |
Common Values
| Value | Count | Frequency (%) |
| METRO-NORTE | 773808 | |
| METRO-SUR | 667679 | |
| CENTRO | 531307 | |
| BAJÍO | 481556 | |
| OCCIDENTE | 407709 | |
| SURESTE | 362945 | |
| NORESTE | 276112 | 6.5% |
| CENTRO-SUR | 225405 | 5.3% |
| PENÍNSULA | 221555 | 5.2% |
| NOROESTE | 183196 | 4.3% |
Length
| Value | Count | Frequency (%) |
| metro-norte | 773808 | |
| metro-sur | 667679 | |
| centro | 531307 | |
| bajío | 481556 | |
| occidente | 407709 | |
| sureste | 362945 | |
| noreste | 276112 | 6.5% |
| centro-sur | 225405 | 5.3% |
| península | 221555 | 5.2% |
| noroeste | 183196 | 4.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 77 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 337.6 MiB |
| Emolor Vocals | |
|---|---|
| Colorvit Ifonforge Industries | 202871 |
| Lorthogus Toughworks | 198650 |
| Thrilthoal Empire | 182213 |
| Thrilmamad Vocals | 162288 |
| Other values (72) |
Length
| Max length | 32 |
|---|---|
| Median length | 17 |
| Mean length | 18.2180059 |
| Min length | 12 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Vitena Vocals |
|---|---|
| 2nd row | Movitalf Empire |
| 3rd row | Gorngusco Toughworks |
| 4th row | Elortho Aerospace |
| 5th row | Marvitrus Ifonforge Industries |
Common Values
| Value | Count | Frequency (%) |
| Emolor Vocals | 347313 | 8.2% |
| Colorvit Ifonforge Industries | 202871 | 4.8% |
| Lorthogus Toughworks | 198650 | 4.7% |
| Thrilthoal Empire | 182213 | 4.3% |
| Thrilmamad Vocals | 162288 | 3.8% |
| Thrilvitar Industrail | 153234 | 3.6% |
| Ioalfio Ifonforge Industries | 149574 | 3.5% |
| Thrilvallor Corp. | 135984 | 3.2% |
| Elortho Aerospace | 128190 | 3.0% |
| Barrusgul Corp. | 113824 | 2.7% |
| Other values (67) | 2480198 |
Length
| Value | Count | Frequency (%) |
| vocals | 1017026 | 11.1% |
| ifonforge | 665559 | 7.3% |
| industries | 665559 | 7.3% |
| corp | 546994 | 6.0% |
| industrail | 518874 | 5.7% |
| toughworks | 427009 | 4.7% |
| emolor | 347313 | 3.8% |
| empire | 344638 | 3.8% |
| inc | 307644 | 3.4% |
| aerospace | 291461 | 3.2% |
| Other values (76) | 4042160 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 32 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 296.8 MiB |
| Alloralf | |
|---|---|
| Magornmar | |
| Thrilvallor | |
| Coalmar | |
| Barthovit | |
| Other values (27) |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.146733723 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Thrilvallor |
|---|---|
| 2nd row | Alloralf |
| 3rd row | Lorgulgus |
| 4th row | Alloralf |
| 5th row | Magornmar |
Common Values
| Value | Count | Frequency (%) |
| Alloralf | 958488 | |
| Magornmar | 675352 | |
| Thrilvallor | 230976 | 5.4% |
| Coalmar | 225968 | 5.3% |
| Barthovit | 222572 | 5.2% |
| Erodmo | 201881 | 4.7% |
| Nabargus | 198445 | 4.7% |
| Alfrusma | 156322 | 3.7% |
| Lorvalmo | 127892 | 3.0% |
| Lorgulgus | 118347 | 2.8% |
| Other values (22) | 1138096 |
Length
| Value | Count | Frequency (%) |
| alloralf | 958488 | |
| magornmar | 675352 | |
| thrilvallor | 230976 | 5.4% |
| coalmar | 225968 | 5.3% |
| barthovit | 222572 | 5.2% |
| erodmo | 201881 | 4.7% |
| nabargus | 198445 | 4.7% |
| alfrusma | 156322 | 3.7% |
| lorvalmo | 127892 | 3.0% |
| lorgulgus | 118347 | 2.8% |
| Other values (22) | 1138096 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 606 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 341.5 MiB |
| Enlightened Dark Empire | |
|---|---|
| Purple Creek | 143626 |
| Evil Chocolate Rock | 107966 |
| Empty Chartreuse Butter | 90343 |
| First Salmon Rock | 81053 |
| Other values (601) |
Length
| Max length | 29 |
|---|---|
| Median length | 19 |
| Mean length | 19.17095887 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Purple Creek |
|---|---|
| 2nd row | Long Chocolate Barrier |
| 3rd row | Horrible Purple Tree |
| 4th row | Funny Magenta Tree |
| 5th row | Enlightened Dark Empire |
Common Values
| Value | Count | Frequency (%) |
| Enlightened Dark Empire | 631506 | 14.8% |
| Purple Creek | 143626 | 3.4% |
| Evil Chocolate Rock | 107966 | 2.5% |
| Empty Chartreuse Butter | 90343 | 2.1% |
| First Salmon Rock | 81053 | 1.9% |
| Evil Azure Metropolis | 71587 | 1.7% |
| Long Lavender Butter | 70285 | 1.7% |
| Last Pink River | 69073 | 1.6% |
| Singing Grey Empire | 66939 | 1.6% |
| Little Silver Polis | 66320 | 1.6% |
| Other values (596) | 2855641 |
Length
| Value | Count | Frequency (%) |
| empire | 792838 | 6.3% |
| dark | 691450 | 5.5% |
| enlightened | 683419 | 5.4% |
| chocolate | 305671 | 2.4% |
| rock | 292359 | 2.3% |
| evil | 285560 | 2.3% |
| purple | 236317 | 1.9% |
| chartreuse | 232293 | 1.8% |
| rare | 206077 | 1.6% |
| butter | 200182 | 1.6% |
| Other values (108) | 8684380 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 308.4 MiB |
| proveedor_2 | |
|---|---|
| proveedor_1 | 331557 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | proveedor_2 |
|---|---|
| 2nd row | proveedor_2 |
| 3rd row | proveedor_2 |
| 4th row | proveedor_2 |
| 5th row | proveedor_2 |
Common Values
| Value | Count | Frequency (%) |
| proveedor_2 | 3922782 | |
| proveedor_1 | 331557 | 7.8% |
Length
Pie chart
| Value | Count | Frequency (%) |
| proveedor_2 | 3922782 | |
| proveedor_1 | 331557 | 7.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 271.7 MiB |
| IV | |
|---|---|
| V | |
| VI | |
| III | |
| II |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 1.970230628 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IV |
|---|---|
| 2nd row | IV |
| 3rd row | IV |
| 4th row | IV |
| 5th row | V |
Common Values
| Value | Count | Frequency (%) |
| IV | 1644414 | |
| V | 675352 | |
| VI | 659255 | |
| III | 647166 | 15.2% |
| II | 529689 | 12.5% |
| I | 98463 | 2.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| iv | 1644414 | |
| v | 675352 | |
| vi | 659255 | |
| iii | 647166 | 15.2% |
| ii | 529689 | 12.5% |
| i | 98463 | 2.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 46 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4455742.654 |
| Minimum | 4220015 |
|---|---|
| Maximum | 4829827 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.9 MiB |
Quantile statistics
| Minimum | 4220015 |
|---|---|
| 5-th percentile | 4240039 |
| Q1 | 4290336 |
| median | 4442378 |
| Q3 | 4615034 |
| 95-th percentile | 4665676 |
| Maximum | 4829827 |
| Range | 609812 |
| Interquartile range (IQR) | 324698 |
Descriptive statistics
| Standard deviation | 155313.5231 |
|---|---|
| Coefficient of variation (CV) | 0.03485693297 |
| Kurtosis | -1.330780289 |
| Mean | 4455742.654 |
| Median Absolute Deviation (MAD) | 152042 |
| Skewness | 0.08813030507 |
| Sum | 1.895623975 × 1013 |
| Variance | 2.412229044 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4554143 | 289770 | 6.8% |
| 4270121 | 288587 | 6.8% |
| 4240039 | 285323 | 6.7% |
| 4330800 | 276087 | 6.5% |
| 4381425 | 273462 | 6.4% |
| 4290336 | 260236 | 6.1% |
| 4442378 | 254123 | 6.0% |
| 4250046 | 252974 | 5.9% |
| 4412040 | 238867 | 5.6% |
| 4533931 | 207049 | 4.9% |
| Other values (36) | 1627861 |
| Value | Count | Frequency (%) |
| 4220015 | 7100 | 0.2% |
| 4230022 | 9114 | 0.2% |
| 4240039 | 285323 | |
| 4250046 | 252974 | |
| 4260053 | 32516 | 0.8% |
| 4270121 | 288587 | |
| 4290336 | 260236 | |
| 4300343 | 3 | < 0.1% |
| 4330800 | 276087 | |
| 4351043 | 8059 | 0.2% |
| Value | Count | Frequency (%) |
| 4829827 | 7209 | 0.2% |
| 4819810 | 9482 | 0.2% |
| 4809797 | 8790 | 0.2% |
| 4789544 | 64 | < 0.1% |
| 4779537 | 32 | < 0.1% |
| 4769520 | 36 | < 0.1% |
| 4759438 | 4 | < 0.1% |
| 4749421 | 21 | < 0.1% |
| 4739414 | 14 | < 0.1% |
| 4729193 | 29589 |
| Distinct | 46 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 346.8 MiB |
| Stars Mango Peach | |
|---|---|
| Squares Chocolate | |
| Lucjy Charms Chocolate | |
| Crunch Mango Peach | 276087 |
| Chocos Mango Peach | 273462 |
| Other values (41) |
Length
| Max length | 42 |
|---|---|
| Median length | 18 |
| Mean length | 20.47953348 |
| Min length | 15 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cups Mango Peach |
|---|---|
| 2nd row | Cups Mango Peach |
| 3rd row | Cups Mango Peach |
| 4th row | Cups Mango Peach |
| 5th row | Cups Mango Peach |
Common Values
| Value | Count | Frequency (%) |
| Stars Mango Peach | 289770 | 6.8% |
| Squares Chocolate | 288587 | 6.8% |
| Lucjy Charms Chocolate | 285323 | 6.7% |
| Crunch Mango Peach | 276087 | 6.5% |
| Chocos Mango Peach | 273462 | 6.4% |
| Toast Chocolate | 260236 | 6.1% |
| Crunchy Bran Mango Peach | 254123 | 6.0% |
| Muesli Chocolate | 252974 | 5.9% |
| Crispy Rice Mango Peach | 238867 | 5.6% |
| Cups Mango Peach | 207049 | 4.9% |
| Other values (36) | 1627861 |
Length
| Value | Count | Frequency (%) |
| mango | 2408661 | |
| peach | 2408661 | |
| chocolate | 1845678 | |
| choc | 709828 | 5.3% |
| chip | 709828 | 5.3% |
| crunch | 510234 | 3.8% |
| toast | 450667 | 3.4% |
| squares | 416108 | 3.1% |
| stars | 296870 | 2.2% |
| chocos | 295026 | 2.2% |
| Other values (31) | 3373946 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 308.6 MiB |
| Sugar-free | |
|---|---|
| Super-flavour |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 11.06647989 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Super-flavour |
|---|---|
| 2nd row | Super-flavour |
| 3rd row | Super-flavour |
| 4th row | Super-flavour |
| 5th row | Super-flavour |
Common Values
| Value | Count | Frequency (%) |
| Sugar-free | 2741950 | |
| Super-flavour | 1512389 |
Length
Pie chart
| Value | Count | Frequency (%) |
| sugar-free | 2741950 | |
| super-flavour | 1512389 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 306.9 MiB |
| Cereal bars | |
|---|---|
| Cereal box |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.6445067 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cereal box |
|---|---|
| 2nd row | Cereal box |
| 3rd row | Cereal box |
| 4th row | Cereal box |
| 5th row | Cereal box |
Common Values
| Value | Count | Frequency (%) |
| Cereal bars | 2741950 | |
| Cereal box | 1512389 |
Length
Pie chart
| Value | Count | Frequency (%) |
| cereal | 4254339 | |
| bars | 2741950 | |
| box | 1512389 | 17.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 352 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.471704587 |
| Minimum | 0.2 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.9 MiB |
Quantile statistics
| Minimum | 0.2 |
|---|---|
| 5-th percentile | 0.25 |
| Q1 | 1 |
| median | 3 |
| Q3 | 9 |
| 95-th percentile | 25 |
| Maximum | 36 |
| Range | 35.8 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 7.975320511 |
|---|---|
| Coefficient of variation (CV) | 1.232336922 |
| Kurtosis | 2.32100284 |
| Mean | 6.471704587 |
| Median Absolute Deviation (MAD) | 2.4 |
| Skewness | 1.726872008 |
| Sum | 27532825.22 |
| Variance | 63.60573726 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 373963 | 8.8% |
| 2 | 280259 | 6.6% |
| 3 | 202443 | 4.8% |
| 0.2 | 169183 | 4.0% |
| 4 | 164160 | 3.9% |
| 0.45 | 134102 | 3.2% |
| 5 | 130206 | 3.1% |
| 6 | 115734 | 2.7% |
| 0.25 | 112142 | 2.6% |
| 0.4 | 108804 | 2.6% |
| Other values (342) | 2463343 |
| Value | Count | Frequency (%) |
| 0.2 | 169183 | |
| 0.25 | 112142 | 2.6% |
| 0.4 | 108804 | 2.6% |
| 0.45 | 134102 | 3.2% |
| 0.5 | 93402 | 2.2% |
| 0.6 | 70646 | 1.7% |
| 0.75 | 64999 | 1.5% |
| 0.8 | 48900 | 1.1% |
| 0.9 | 87473 | 2.1% |
| 1 | 373963 |
| Value | Count | Frequency (%) |
| 36 | 10291 | |
| 35.91 | 135 | < 0.1% |
| 35.8 | 14 | < 0.1% |
| 35.75 | 89 | < 0.1% |
| 35.6 | 7 | < 0.1% |
| 35.55 | 27 | < 0.1% |
| 35.5 | 65 | < 0.1% |
| 35.4 | 13 | < 0.1% |
| 35.25 | 86 | < 0.1% |
| 35.2 | 15 | < 0.1% |
| Distinct | 3123 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.48734904 |
| Minimum | 1 |
|---|---|
| Maximum | 28.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5.17 |
| Q1 | 10.1 |
| median | 16 |
| Q3 | 17.6 |
| 95-th percentile | 22.6 |
| Maximum | 28.2 |
| Range | 27.2 |
| Interquartile range (IQR) | 7.5 |
Descriptive statistics
| Standard deviation | 5.193937571 |
|---|---|
| Coefficient of variation (CV) | 0.3585153887 |
| Kurtosis | -0.729426986 |
| Mean | 14.48734904 |
| Median Absolute Deviation (MAD) | 3.6 |
| Skewness | -0.1557830016 |
| Sum | 61634094.02 |
| Variance | 26.97698749 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 255916 | 6.0% |
| 9.7 | 242760 | 5.7% |
| 17.5 | 213090 | 5.0% |
| 5 | 198554 | 4.7% |
| 21.5 | 193607 | 4.6% |
| 17.6 | 170888 | 4.0% |
| 16.4 | 155741 | 3.7% |
| 18 | 145508 | 3.4% |
| 16.8 | 122287 | 2.9% |
| 10.2 | 117760 | 2.8% |
| Other values (3113) | 2438228 |
| Value | Count | Frequency (%) |
| 1 | 5 | |
| 1.03 | 1 | < 0.1% |
| 1.111111111 | 8 | |
| 1.13 | 1 | < 0.1% |
| 1.2 | 1 | < 0.1% |
| 1.21 | 1 | < 0.1% |
| 1.25 | 4 | |
| 1.35 | 1 | < 0.1% |
| 1.4 | 5 | |
| 1.402116402 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 28.2 | 89 | |
| 28.16 | 10 | < 0.1% |
| 28.14 | 2 | < 0.1% |
| 28.13 | 1 | < 0.1% |
| 28.12 | 7 | < 0.1% |
| 28.11 | 1 | < 0.1% |
| 28.08 | 11 | < 0.1% |
| 28.07 | 3 | < 0.1% |
| 28.06666667 | 1 | < 0.1% |
| 28.05 | 2 | < 0.1% |
| Distinct | 52949 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 99.1939017 |
| Minimum | 0.3 |
|---|---|
| Maximum | 611.226 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.9 MiB |
Quantile statistics
| Minimum | 0.3 |
|---|---|
| 5-th percentile | 2.1 |
| Q1 | 13.35 |
| median | 41.6 |
| Q3 | 135.45 |
| 95-th percentile | 397.6 |
| Maximum | 611.226 |
| Range | 610.926 |
| Interquartile range (IQR) | 122.1 |
Descriptive statistics
| Standard deviation | 127.3468747 |
|---|---|
| Coefficient of variation (CV) | 1.283817579 |
| Kurtosis | 2.602744921 |
| Mean | 99.1939017 |
| Median Absolute Deviation (MAD) | 35.78 |
| Skewness | 1.779073244 |
| Sum | 422004484.6 |
| Variance | 16217.2265 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.94 | 66014 | 1.6% |
| 9.675 | 50899 | 1.2% |
| 3.88 | 40662 | 1.0% |
| 2.04 | 37575 | 0.9% |
| 1.25 | 36944 | 0.9% |
| 17.6 | 35283 | 0.8% |
| 16 | 35064 | 0.8% |
| 16.4 | 34516 | 0.8% |
| 17.5 | 31718 | 0.7% |
| 18 | 30714 | 0.7% |
| Other values (52939) | 3854950 |
| Value | Count | Frequency (%) |
| 0.3 | 1 | < 0.1% |
| 0.38 | 1 | < 0.1% |
| 0.5 | 3 | |
| 0.55 | 1 | < 0.1% |
| 0.6 | 2 | |
| 0.62 | 1 | < 0.1% |
| 0.63 | 3 | |
| 0.65 | 1 | < 0.1% |
| 0.75 | 1 | < 0.1% |
| 0.99 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 611.226 | 1 | < 0.1% |
| 611.136 | 1 | < 0.1% |
| 611.1 | 25 | |
| 611.1 | 7 | < 0.1% |
| 611.055 | 7 | < 0.1% |
| 611.0325 | 1 | < 0.1% |
| 611.01 | 1 | < 0.1% |
| 610.98 | 4 | < 0.1% |
| 610.92 | 4 | < 0.1% |
| 610.83 | 1 | < 0.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| id | date | store_id | format | store_name | structure | division | deposit/distributor | state | municipality/city | supplier | grade | sku | sku_description | sku_category | sku_subcategory | units | unit_price | total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 2016-01-01 | 2934 | Grocery | Old Indigo BigCom | FORANEO | CENTRO | Vitena Vocals | Thrilvallor | Purple Creek | proveedor_2 | IV | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 0.45 | 21.5 | 9.675 |
| 1 | 15 | 2016-01-01 | 3098 | AllInOne | Dead Burgundy Shop | DISTRIBUIDORES | CENTRO | Movitalf Empire | Alloralf | Long Chocolate Barrier | proveedor_2 | IV | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 15.75 | 21.5 | 338.625 |
| 2 | 19 | 2016-01-01 | 2026 | AllInOne | Kicking Orange HairDresser | FORANEO | CENTRO-SUR | Gorngusco Toughworks | Lorgulgus | Horrible Purple Tree | proveedor_2 | IV | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 2.25 | 21.5 | 48.375 |
| 3 | 32 | 2016-01-01 | 2343 | Leftorium | Funny Maroon LunchHall | FORANEO | CENTRO | Elortho Aerospace | Alloralf | Funny Magenta Tree | proveedor_2 | IV | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 0.90 | 21.5 | 19.350 |
| 4 | 64 | 2016-01-01 | 1533 | Grocery | Defiant Red Mall | METRO | METRO-NORTE | Marvitrus Ifonforge Industries | Magornmar | Enlightened Dark Empire | proveedor_2 | V | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 4.50 | 21.5 | 96.750 |
| 5 | 107 | 2016-01-01 | 1225 | Grocery | Short Navy Cafe | FORANEO | CENTRO-SUR | Erodmad Industrail | Egusgul | Clean Aqua Soil | proveedor_2 | IV | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 1.35 | 21.5 | 29.025 |
| 6 | 156 | 2016-01-01 | 2024 | AllInOne | Alive Beige Grocery | FORANEO | SURESTE | Eioval Aerospace | Coalmar | Rare Orange Applepie | proveedor_2 | VI | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 0.45 | 21.5 | 9.675 |
| 7 | 160 | 2016-01-01 | 3820 | GipsyTrade | Little Orchid Bank | METRO | METRO-SUR | Ioalfio Ifonforge Industries | Magornmar | Enlightened Dark Empire | proveedor_2 | V | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 0.90 | 21.5 | 19.350 |
| 8 | 173 | 2016-01-01 | 3694 | Grocery | Kicking Beige SuperMarket | FORANEO | CENTRO-SUR | Gorngusco Toughworks | Lorgulgus | Horrible Purple Tree | proveedor_2 | IV | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 0.45 | 21.5 | 9.675 |
| 9 | 206 | 2016-01-01 | 2906 | Grocery | Little Pink LunchHall | FORANEO | CENTRO | Elortho Aerospace | Alloralf | Funny Magenta Tree | proveedor_2 | IV | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 1.35 | 21.5 | 29.025 |
Last rows
| id | date | store_id | format | store_name | structure | division | deposit/distributor | state | municipality/city | supplier | grade | sku | sku_description | sku_category | sku_subcategory | units | unit_price | total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4254329 | 5489354 | 2017-06-04 | 118 | Shop | First Azure Florist | FORANEO | PENÍNSULA | Alfthrilal Vocals | Mamoval | First Blue Rock | proveedor_1 | VI | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 2.00 | 27.2 | 54.4 |
| 4254330 | 5489383 | 2017-06-04 | 253 | Shop | Short Green Bank | FORANEO | PENÍNSULA | Valalar Aerospace | Egusco | Great Golden Applepie | proveedor_1 | VI | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 0.50 | 27.2 | 13.6 |
| 4254331 | 5489398 | 2017-06-04 | 119 | Shop | Dirty Lime SuperMarket | FORANEO | OCCIDENTE | Colorvit Ifonforge Industries | Nabargus | Old Sea Green Soil | proveedor_1 | III | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 0.75 | 27.2 | 20.4 |
| 4254332 | 5489451 | 2017-06-04 | 117 | Shop | Impressive Indigo Grocery | METRO | METRO-NORTE | Emolor Vocals | Alloralf | Horrible Chartreuse Mud | proveedor_1 | IV | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 3.75 | 27.2 | 102.0 |
| 4254333 | 5489465 | 2017-06-04 | 254 | Shop | Legendary Crimson TallMarket | FORANEO | CENTRO-SUR | Gorngusco Toughworks | Lorgulgus | Horrible Purple Tree | proveedor_1 | IV | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 0.25 | 27.2 | 6.8 |
| 4254334 | 5489499 | 2017-06-04 | 121 | Shop | Massive Purple HighShop | METRO | METRO-SUR | Thrilthoal Empire | Magornmar | Funny Lemon Star | proveedor_1 | V | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 5.50 | 27.2 | 149.6 |
| 4254335 | 5489508 | 2017-06-04 | 251 | Shop | Dirty Sky Blue BigCenter | FORANEO | BAJÍO | Lormarmad Corp. | Eemar | Legendary Lavender Key | proveedor_1 | II | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 2.25 | 27.2 | 61.2 |
| 4254336 | 5489509 | 2017-06-04 | 125 | Shop | Short Sky Blue TinyShop | FORANEO | NOROESTE | Lorealf Industrail | Valargorn | Tall Indigo Capital | proveedor_1 | II | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 1.25 | 27.2 | 34.0 |
| 4254337 | 5489553 | 2017-06-04 | 120 | Shop | Dead Sky Blue Grocery | FORANEO | SURESTE | Eioval Aerospace | Coalmar | Rare Orange Applepie | proveedor_1 | VI | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 0.75 | 27.2 | 20.4 |
| 4254338 | 5489571 | 2017-06-04 | 9 | Shop | Alive Purple Baker | DISTRIBUIDORES | SURESTE | Arbarrus Gmbh | Coalmar | Kicking Crimson Key | proveedor_1 | VI | 4829827 | Golden Goals Chocolate Choc Chip | Sugar-free | Cereal bars | 1.00 | 27.2 | 27.2 |